Data Sources and Targets Reference
Pyramid also supports custom connectors, which can be configured in the Admin console.
- Click here to learn about custom connectors.
Source |
|
Direct Query |
Target |
Compatible with Pulse |
Configuration |
---|---|---|---|---|---|
Access |
|
|
Local file upload, or pointer to a shared file on a network drive |
||
Amazon Athena |
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
|
Amazon S3 |
Requires setup and configuration in Administration. |
||||
Apache Drill ## |
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
|
Apache Hive ## |
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
|
Apache Presto |
|
|
|
Requires setup and configuration in Administration. |
|
Azure Blob |
|
|
|
Requires setup and configuration in Administration. |
|
Azure Synapse |
|
|
|
|
Requires setup and configuration in Administration. |
Box |
|
|
|
|
Requires setup and configuration in Administration. |
Custom JDBC |
|
|
|
|
Requires setup and configuration in Administration.
While Direct Query models may be built using Custom Connectors, Pyramid cannot guarantee full operational functionality when queries are run. Pyramid will not offer support for Direct Query models built using Custom Connectors. Direct querying for Custom Connectors is not available in the Community edition. |
ClickHouse ## |
|
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
Databricks |
|
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
DB2 |
|
|
|
Requires setup and configuration in Administration. |
|
DB2 AS400 |
|
|
|
|
Requires setup and configuration in Administration. |
Denodo |
|
|
|
|
Requires setup and configuration in Administration. |
Dremio |
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
|
Exasol |
|
|
|
|
Requires setup and configuration in Administration. |
Excel |
|
Local file upload, or pointer to a shared file on a network drive, or URL Address |
|||
|
|
|
|
Requires setup and configuration in Administration. |
|
Firebird |
|
|
|
Requires setup and configuration in Administration. |
|
FTP |
|
|
|
|
Requires setup and configuration in Administration. |
Glue (Datavard) |
|
|
|
|
Requires setup and configuration in Administration. |
Google Analytics |
Requires setup and configuration in Administration. |
||||
Google BigQuery |
|
|
|
Requires setup and configuration in Administration. |
|
Google Drive |
|
|
|
Requires setup and configuration in Administration. |
|
Google Sheets |
|
|
|
|
ID or URL address |
Greenplum (Pivotal) |
|
|
|
Requires setup and configuration in Administration. |
|
IBM Informix |
|
|
|
Requires setup and configuration in Administration. |
|
Impala ## |
|
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
JSON |
|
Local file upload, or pointer to a shared file on a network drive, or URL Address |
|||
MariaDB |
|
|
|
|
Requires setup and configuration in Administration. |
MS OLAP |
|
|
|
|
Requires setup and configuration in Administration. MS OLAP sources can be directly queried without any setup in Model. |
MS Tabular |
|
|
|
|
Includes Azure SSAS Tabular and Power BI Workspaces. Requires setup and configuration in Administration. Tabular sources can be directly queried without any setup in Model. MS Tabular models can be built in Model by connecting to an SQL target, and then loading the model's metadata into a Tabular target. |
Mongo BI CX ## |
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
||
Multi Files |
|
|
|
Enter the shared folder path and the files to include in the upload. Each file must have the same structure (columns). Note: this data source is not available in the Community Edition. |
|
MySQL |
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
|
Neo4j BI Connector ## |
|
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
Neo4j Cypher ## |
|
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
Netezza ## |
|
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
NetSuite## |
|
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
OData |
Requires configuration in the client (add the node to the Data Flow and enter the OData Service URL in the Properties panel) |
||||
ODBC |
Requires setup and configuration in Administration. Click here for details. |
||||
ODBC Direct |
|
|
|
|
Requires setup and configuration in Administration. For details, see ODBC Setup. |
Oracle |
|
|
|
Requires setup and configuration in Administration. |
|
PostgreSQL |
|
|
|
Requires setup and configuration in Administration. |
|
Pyramid In Memory |
|
|
|
|
Use Pyramid's in memory database as a datasource and / or target. Click here to learn more. |
Pyramid Queries |
N/A |
N/A |
Use Pyramid reports (data discoveries) as a data source. Click here to learn more. |
||
Python as a source |
N/A |
N/A |
Only supported in Model Pro |
||
R as a source |
N/A |
N/A |
Only supported in Model Pro |
||
Redshift |
|
|
|
Requires setup and configuration in Administration. |
|
RSS |
|
|
|
Add the Feed URL in the Properties panel |
|
SalesForce |
|
Requires setup and configuration in Administration |
|||
SAP BW |
|
|
|
|
Requires setup and configuration in Administration. Supports direct querying only - there is no option to build an ETL for SAP BW. Click here to learn more. |
SAP Datasphere |
|
|
|
|
Requires setup and configuration in Administration. Both ETL and direct querying are supported for SAP Datasphere. Click here to learn more. |
SAP HANA |
|
|
|
Requires setup and configuration in Administration. Both ETL and direct querying are supported for SAP HANA. Click here to learn more. |
|
SAS Data Set |
|
|
|
Local file upload, or pointer to a shared .sas7bdat file on a network drive, or URL Address |
|
SFTP |
|
|
|
|
Requires setup and configuration in Administration. |
SharePoint Lists |
|
|
|
Requires setup and configuration in Administration. |
|
SingleStore |
|
|
|
|
Requires setup and configuration in Administration. |
Snowflake |
|
|
|
Requires setup and configuration in Administration. |
|
Spark |
|
|
|
|
Requires driver from Connectors Marketplace as part of setup and configuration in Administration. |
SQL Server |
|
|
|
Requires setup and configuration in Administration. |
|
SQL Server Azure |
|
|
|
Requires setup and configuration in Administration. |
|
Sybase / SAP |
|
|
|
Requires setup and configuration in Administration. Select Shared Folder property |
|
Starburst |
|
|
|
|
Requires setup and configuration in Administration. |
Teradata |
|
|
|
Requires setup and configuration in Administration. |
|
|
Local file upload, or pointer to a shared file on a network drive, or URL Address. Select the encoding of the file. Supports both Fixed Width Column files and Delimited files. Custom delimiters are supported - type the delimiter into the Delimiters window in the Properties panel. |
||||
Vertica |
|
|
|
Requires setup and configuration in Administration. |
|
X (Twitter) |
|
|
|
Requires setup and configuration in Administration. |
|
XML |
|
Local file upload, or pointer to a shared file on a network drive, or URL Address |
## These drivers are not bundled in the main installer as of 2020.24 for various reasons. Customers wishing to use them can download the connectors and upload them manually from the Connectors Marketplace found in the custom connector administrative interface.
Note: If users have rights, they can setup configurable data sources themselves directly from inside the data modeling tools.
Pass-through Direct Query
Pass-through datasources can be natively queried by Pyramid with direct queries. This means that the data does not need to be pre-processed or copied by Pyramid (or any other technology) before it can be queried by users.
- Click here to learn more about direct querying.
Note: MS Analysis Services (OLAP and Tabular) can be directly queried using their existing cubes and tabular models.
MS SQLServer Index Usage
When text parameters are passed to queries, Pyramid matches the Text type, VARCHAR or NVARCHAR, of the target text fields. This enables the utilization of any indexes that are present against those target text fields providing enhanced query performance.
Data Targets
'Targets' in data preparation allows Pyramid to mash up data and WRITE the resulting database to the targeted technology and designated server. Given that Pyramid can write to a variety of data stacks, the targeting options give users a wide variety of options on where to build intermediate models and how to correct issues with their data before they start the analysis process.
- Click here to learn more about targets.
Pulse
A number of datasources are compatible with Pulse. When connecting to a Pulse datasource, you may opt to directly query the datasource, or you may add select or multi-select nodes to perform data streaming.
- Click here to learn more about Pulse, including how to configure Pulse nodes in the Admin console.